IF EXISTS (SELECT *
           FROM INFORMATION_SCHEMA.VIEWS
           WHERE TABLE_NAME='vXXXXX'
           AND TABLE_SCHEMA='dbo'
          )
          DROP VIEW dbo.vXXXXX
GO

CREATE VIEW dbo.vXXXXX
AS
/*@@*_____________________________________________________________________


_____________________________________________________________________*@@*/

  SELECT
    ...
  FROM
    ...



